Pen : MySQL Load Balancing
2015/01/31 |
Configure Pen to Load Balance to 2 MySQL backends.
| -------+----------------------------------------------- | +-------------------+--------------------+ |10.0.0.30 |10.0.0.51 |10.0.0.52 +-----+------+ +-------+------+ +-------+------+ | Frontend | | Backend#1 | | Backend#2 | | Pen Server | | MySQL Server | | MySQL Server | +------------+ +--------------+ +--------------+ |
[1] | Configure Pen. Before this section, configure basic settings. |
[root@dlp ~]#
vi /etc/pen.conf # create new
LOGFILE=/var/log/pen.log
WEBFILE=/var/www/pen/webstats.html CONTROL=127.0.0.1:10080 MAX_CONNECTIONS=256 ROUNDROBIN=true # listening port PORT=3306 # number of backends BACKEND=2 # define backend servers SERVER1=10.0.0.51:3306 SERVER2=10.0.0.52:3306 /etc/rc.d/init.d/pend restart Stopping Pend: [ OK ] Starting Pend: [ OK ] |
[2] | Make sure all works fine to access to the frontend server from a Client with SQL like follows. |
[root@desktop ~]# mysql -u keystone -p -h 10.0.0.30 keystone -e "select * from table01;" Enter password: +------+-------------------+ | id | name | +------+-------------------+ | 1 | db01.srv.world | +------+-------------------+[root@desktop ~]# mysql -u keystone -p -h 10.0.0.30 keystone -e "select * from table01;" Enter password: +------+-------------------+ | id | name | +------+-------------------+ | 1 | db02.srv.world | +------+-------------------+ |